'.$row['numebut'.$lng].''; else { if ($row['id']!=3 and $row['id']!=4) $mainmenu.=''.$row['numebut'.$lng].''; else $mainmenu.=''.$row['numebut'.$lng].''; } } return $mainmenu; } function afisarepagina($idpagina,$lang) { if ($lang=='ro') $lng=''; else if ($lang=='de') $lng='en'; else $lng=$lang; global $continut,$title,$description,$keywords; $result=mysql_query("SELECT * FROM pagini where id='$idpagina'"); if (mysql_num_rows($result)!=NULL) { if ($lng!='favicon.ico') { $keywords=mysql_result($result,0,'keywords'.$lng); $description=mysql_result($result,0,'description'.$lng); $title=mysql_result($result,0,'titlu'.$lng); $continut.=mysql_result($result,0,'continut'.$lng); } } } //end tabela pagini //afisare categorii function afiscategorii($dir,$catname,$subcatname,$subsubname,$nivelcurent,$idcat,$lang) {$lng=''; $men=''; $men1=''; $idcatz=$idcat; global $continut,$title,$keywords,$description,$linkconstr,$men1,$script2, $meniucatmob; if ($nivelcurent=='producator' or $nivelcurent=='producatori') $idcat=23; $idz=$idcat; if ($nivelcurent=='produse') { $rixx=mysql_query("SELECT idcat,idparinte from subcategorii where id='$idz' LIMIT 1"); if (mysql_num_rows($rixx)!=NULL) if (mysql_result($rixx,0,'idcat')!=0) $idcat=mysql_result($rixx,0,'idcat'); else { $rixx2=mysql_query("SELECT idcat,idparinte from subcategorii where id='".mysql_result($rixx,0,'idparinte')."' LIMIT 1"); if (mysql_num_rows($rixx2)!=NULL) if (mysql_result($rixx2,0,'idcat')!=0) {$idcat=mysql_result($rixx2,0,'idcat'); } } } if ($nivelcurent=='produs') { $ramx=mysql_query("SELECT categorie from produse where id='$idz' LIMIT 1"); if (mysql_num_rows($ramx)!=NULL) $idz=mysql_result($ramx,0,'categorie'); $rixx=mysql_query("SELECT idcat,idparinte from subcategorii where id='$idz' LIMIT 1"); if (mysql_num_rows($rixx)!=NULL) if (mysql_result($rixx,0,'idcat')!=0) $idcat=mysql_result($rixx,0,'idcat'); else { $rixx2=mysql_query("SELECT idcat,idparinte from subcategorii where id='".mysql_result($rixx,0,'idparinte')."' LIMIT 1"); if (mysql_num_rows($rixx2)!=NULL) if (mysql_result($rixx2,0,'idcat')!=0) {$idcat=mysql_result($rixx2,0,'idcat'); } } } $result=mysql_query("SELECT * FROM categorii order by pozitie"); if (mysql_num_rows($result)!=NULL) { $meniucatmob=''; while ($row=mysql_fetch_array($result)) { if ($idcat==$row['id']) $still=' style="background-color:#ccc;color:#CC0000;" '; else $still=''; if ($row['id']==1 and $_GET['var1']=='') $still=' style="background-color:#ccc;color:#CC0000;" '; $men1.=''.$row['titlu'.$lng].''; $meniucatmob.='

'.$row['titlu'.$lng].'

'; } } $result=mysql_query("SELECT * FROM subcategorii where idcat='$idcat' order by pozitie"); if (mysql_num_rows($result)) while ($row=mysql_fetch_array($result)) { if ($row['id']!=169) $rez=mysql_query("SELECT * FROM subcategorii where idparinte='".$row['id']."' order by pozitie"); else $rez=mysql_query("SELECT * FROM subcategorii where idparinte='".$row['id']."' order by numebut"); if (mysql_num_rows($rez)!=NULL) { $men.=''.$row['numebut'].' '; $men.='

'; while ($rand=mysql_fetch_array($rez)) { $altstil=''; if ($_SESSION['idcatz']==$rand['id']) {$altstil='background-color:#ccc;'; $script2.=' ';} $men.=''.$rand['numebut'].' '; if ($rand['id']!='253') $rix=mysql_query("SELECT id from produse where (categorie='".$rand['id']."' or categorie2='".$rand['id']."' or categorie3='".$rand['id']."' or categorie4='".$rand['id']."' or categorie5='".$rand['id']."' or categorie6='".$rand['id']."' or categorie7='".$rand['id']."') and pret>0"); else $rix=mysql_query("SELECT id from produse where chilipir=1"); if ($row['id']==169) { $rix=mysql_query("SELECT id from produse where (categorie='".$rand['id']."' or categorie2='".$rand['id']."' or categorie3='".$rand['id']."' or categorie4='".$rand['id']."' or categorie5='".$rand['id']."' or categorie6='".$rand['id']."' or categorie7='".$rand['id']."') and pret>0"); } if (mysql_num_rows($rix)!=NULL) $men.='('.mysql_num_rows($rix).')'; else $men.='(0)'; $men.=''; } $men.='

'; } else { $men.=''.$row['numebut'].' '; if ($row['id']!='132') $rix=mysql_query("SELECT id from produse where categorie='".$row['id']."'"); else $rix=mysql_query("SELECT id from produse where chilipir=1"); if (mysql_num_rows($rix)!=NULL) $men.='('.mysql_num_rows($rix).')'; else $men.='(0)'; $men.=''; } } if (($idcat>1)) { $rim=mysql_query("SELECT * FROM categorii where id='$idcat' LIMIT 1"); if (mysql_num_rows($rim)!=NULL) { $men.='

Oferta '.mysql_result($rim,0,'titlu').' PDF | CSV

'; } } return $men; } //end afisare categorii //schimba limba //end schimbalimba //tabela articole function articole($numepag,$director,$idparinte) { $mainmenu=''; //director e calea default catre site $result=mysql_query("SELECT * FROM articole where idparinte='$idparinte'"); if (mysql_num_rows($result)!=NULL) {while ($row=mysql_fetch_array($result)) $mainmenu.=''.$row['numebut'].'
'.$row['minidescr'].''; } return $mainmenu; } function afisarearticol($ida) { global $continut,$title,$description,$keywords; $result=mysql_query("SELECT * FROM articole where id='$ida'"); if (mysql_num_rows($result)!=NULL) { $keywords=mysql_result($result,0,'keywords'); $description=mysql_result($result,0,'description'); $title=mysql_result($result,0,'title'); $continut.=mysql_result($result,0,'continut'); } } //end tabela articole //video function video() { $mainmenu=''; //director e calea default catre site $result=mysql_query("SELECT * FROM video order by id desc"); if (mysql_num_rows($result)!=NULL) {while ($row=mysql_fetch_array($result)) $mainmenu.='

'.$row['video'].'

'; } return $mainmenu; } //end video function adaugacomentariu($idp) { global $continut; if ($_POST['step']=='addcom') { $err=0; if ($_POST['vrf']!=8) {$err=1; $continut.='Verificarea este incorecta
';} else { if (strlen($_POST['nume'])<3) {$err=1; $continut.='Va rugam sa introduceti numele dvs.
';} else if (strlen($_POST['email'])<63) {$err=1; $continut.='Va rugam sa introduceti e-mail-ul dvs.
';} else if (strlen($_POST['comentariu'])<5) {$err=1; $continut.='Va rugam sa introduceti un comentariu valid.
';} } if ($err==1) $continut.=''; if ($err==0) { $continut.'

Comentariul a fost adaugat. El va apare dupa validarea de catre un administrator

'; mysql_query("INSERT into comentarii(nume,email,comentariu,idarticol,data) VALUES('".mysql_escape_string($_POST['nume'])."','".mysql_escape_string($_POST['email'])."','".mysql_escape_string($_POST['comentariu'])."','".mysql_escape_string($_POST['idp'])."','".date("Y-m-d")."')"); } } if ($_POST['step']!='addcom') $continut.=''; } function comentarii($idarticol) { $mainmenu=''; //director e calea default catre site $result=mysql_query("SELECT * FROM comentarii where idarticol='$idarticol' and status=1 order by data desc"); if (mysql_num_rows($result)!=NULL) {while ($row=mysql_fetch_array($result)) $mainmenu.='

In data de '.$row['data'].' '.$row['nume'].' a spus:
'.$row['comentariu'].'

'; } return $mainmenu; } //tabela categorii //doar categorii simple function meniu($numecat,$director) { $mainmenu=''; //director e calea default catre site $result=mysql_query("SELECT * FROM categorii order by pozitie"); if (mysql_num_rows($result)!=NULL) { while ($row=mysql_fetch_array($result)) $mainmenu.=''.$row['numebut'].''; } return $mainmenu; } function afisarecat($idcat) { global $continut,$title,$description,$keywords; $result=mysql_query("SELECT * FROM categorii where id='$idcat'"); if (mysql_num_rows($result)!=NULL) { $keywords=mysql_result($result,0,'keywords'); $description=mysql_result($result,0,'description'); $title=mysql_result($result,0,'title'); $continut.=mysql_result($result,0,'continut'); } } //end tabela categorii //tabela carti function carti($idcat,$director,$numecarte,$pag,$segment) { //numecarte reprezinta link-ul ala de la carte if ($pag>0) $dela=($pag-1)*20; else $dela=0; // e cu paginare cu tot //director e calea default catre site global $continut; $result=mysql_query("SELECT * FROM dbcarti where idcat='$idcat' order by title LIMIT $dela,20"); if (mysql_num_rows($result)!=NULL) { while ($row=mysql_fetch_array($result)) $continut.=''.$row['title'].''; } $result=mysql_query("SELECT * FROM dbcarti where idcat='$idcat'"); if (mysql_num_rows($result)!=NULL) { $continut.='

'; $tot=mysql_num_rows($result); $n=$tot/20; $continut.='1'; for ($i=1;$i<$n;$i++) $continut.=''.($i+1).''; $continut.='

'; } } function afisarecarte($iddoc) { global $continut,$title,$description,$keywords,$docid; $result=mysql_query("SELECT * FROM dbcarti where id='$iddoc'"); if (mysql_num_rows($result)!=NULL) { $keywords=mysql_result($result,0,'title'); $description=mysql_result($result,0,'description'); $title=mysql_result($result,0,'title'); $docid.=mysql_result($result,0,'docid'); } } function cautare($cautat,$director,$numecarte) { if (strlen($cautat)>1) { $cautat=str_replace("-"," ",rpl($cautat)); //numecarte reprezinta link-ul ala de la carte if ($pag>0) $dela=($pag-1)*20; else $dela=0; // e cu paginare cu tot //director e calea default catre site global $continut,$keywords,$description,$title; $keywords=ucfirst($cautat); $description=$keywords.' si multe alte carti electronice gratis le puteti gasi pe acest site'; $title=$keywords; $continut.='

Rezultatele cautarii '.$title.'

Cautarea '.$title.' este oferita in mod gratuit de catre Carti Electronice Gratis

'; $result=mysql_query("SELECT * FROM dbcarti where title REGEXP '$cautat' or description REGEXP '$cautat' order by title LIMIT 100"); if (mysql_num_rows($result)!=NULL) { while ($row=mysql_fetch_array($result)) $continut.=''.$row['title'].''; } mysql_query("INSERT into cautari(cuv) VALUES('".rpl($cautat)."')"); } } //end tabela carti //tabela cautari function ultimelecautari($dirname,$cautanume) { $result=mysql_query("SELECT cuv from cautari order by id desc limit 10"); if (mysql_num_rows($result)!=NULL) { while ($row=mysql_fetch_array($result)) $cautari.=''.ucwords(str_replace("-"," ",$row['cuv'])).''; } return $cautari; } //end tabela ultimele cautari ?>'; if ($wishlist==1) $continut.=''; if ($galben=='') $continut.='

'.substr($row['numebut'],0,90).'

'; else $continut.='

'.ucfirst(str_ireplace($galben,''.$galben.'',substr($row['numebut'],0,90))).'

'; $continut.='

'.$row['numebut'].'

'; if ($row['dataaparitiei']>=date("Y-m-d",strtotime("-3 Months"))) $continut.='

'; $continut.='

'; if ($row['idautor']>1 and $row['idautor']!=859) { $rez=mysql_query("SELECT * FROM autori where id='".$row['idautor']."' LIMIT 1"); if (mysql_num_rows($result)!=NULL) { if ($galben=='') $continut.=''.mysql_result($rez,0,'prenume').' '.mysql_result($rez,0,'nume').''; else $continut.=''.ucwords(str_ireplace($galben,''.$galben.'',mysql_result($rez,0,'prenume').' '.mysql_result($rez,0,'nume'))).''; } } if ($row['ideditura']==1) { $continut.='
Ed. Agaton (-'.cifre('reducereedagaton').'%)
'; } if (mysql_result($result,0,'chilipir')==1) $continut.=' (chilipir) '; $continut.='

'; $carti=0; $regu=mysql_query("SELECT idparinte from subcategorii where id='".$row['categorie']."' LIMIT 1"); if (mysql_num_rows($regu)) $rezu=mysql_query("SELECT idcat from subcategorii where id='".mysql_result($regu,0,'idparinte')."'"); if (mysql_num_rows($rezu)) if (mysql_result($rezu,0,'idcat')==1) $carti=1; if ($carti==1) $continut.='

Preţ:
'.cnv($row['pret'],$row['moneda'],$_SESSION['moneda']).''.ucfirst($_SESSION['moneda']).' '.cnv(reducereeditura($row['ideditura'],$row['pret']),$row['moneda'],$_SESSION['moneda']).' '.ucfirst($_SESSION['moneda']).'

'; else $continut.='

Preţ:'.cnv($row['pret'],$row['moneda'],$_SESSION['moneda']).'
'.ucfirst($_SESSION['moneda']).'

'; /* $continut.=' '; */ if ($row['lacerere']==0) $continut.='

'; $continut.='

'; $continut.=' '; } return '

'.$continut.'

'; } ?>